CREATE TABLE [dbo].[JOL_Employer]
(
[JOL_Employer_No] [int] NOT NULL IDENTITY(1, 1),
[JOL_Employer_Account] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[JOL_Employer_Password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_Industry] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_Province] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_City] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_Address] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_ZipCode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_HomePage] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_Introduction] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_Linkman] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_Mobile] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_Phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_Fax] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_AddTime] [datetime] NULL,
[JOL_Employer_UpdateTime] [datetime] NULL,
[JOL_Employer_VerifyStatus] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_Credentials] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_IsSchoolCorperate] [bit] NULL,
[JOL_Employer_IsContactVisible] [bit] NULL,
[JOL_Employer_IsVIP] [bit] NULL,
[JOL_Employer_CredentialsFileLink] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_AddUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_UpdateUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_VerifyUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employer_VerifyTime] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_Employer] ADD CONSTRAINT [PK__JOL_Employer__1A54DAB7] PRIMARY KEY CLUSTERED  ([JOL_Employer_No]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_Employer] ADD CONSTRAINT [UQ__JOL_Employer__1B48FEF0] UNIQUE NONCLUSTERED  ([JOL_Employer_Account]) ON [PRIMARY]
GO
